package davion.study.summercloud.mapper;

import davion.study.summercloud.model.FileStoreStatistics;
import org.apache.ibatis.annotations.Select;

/**
 * @author: Davion
 * @date: 2020/6/16
 * @description:
 */
public interface MyFileExtMapper {
    @Select("select sum(type = 1) doc,sum(type = 2) image,sum(type = 3) video,sum(type = 4) music,sum(type = 5) other, count(*) fileCount from my_file where store_id=#{id}")
    FileStoreStatistics getCountStatics(Integer id);
}
